Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

Online

COVID 19 Demystified course

At the end of this course, learners should be able to better understand the science and numbers behindCOVID-19 and the SARS-CoV-2 virus that causes it. They should be able to discuss the pandemic with confidence, giving substantiated viewpoints on matters such as public policy with a willingness to accept other viewpoints. ...

Online

Who wants to be a millionaire?

This lesson sequence uses the well-known wheat/rice and chessboard problem as students use spreadsheets to simulate iteration and to solve problems.

Online

Hot or not?

This lesson sequence focuses on the incremental or Agile approach to development and encourages students to follow the evolution of a temperature conversion tool for a Food Technology teacher. It uses an Excel spreadsheet application as the prototyping tool.

Online

Spreadsheets come alive

In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).

Online

Seeing the wood for the trees

In this lesson sequence students summarise data using advanced filtering and grouping techniques, for example pivot tables in spreadsheets and aggregation functions in databases.

Text

ACARA sample assessment task: years 9-10

This resource provides strategies for assessing students' ability to interpret, process, analyse and represent data using spreadsheets, pivot tables, plotting data and scripting activities. A link to a data set from a koala hospital provides extensive data for students to use. The resource includes maps, graphs and charts, ...

Text

ICT Proficiency Teacher self-assessment matrix

These matrices allow teachers to self-assess their ICT Capability and Digital Technologies proficiency. They include a notes section for teachers to plan future professional learning.

Text

Curzon & Bell et al. review: Computational thinking

This article explores the concept of computational thinking within computer science learning and in relation to other learning areas. The authors assert that because of its focus on analysis, computational thinking is not only suitable for computation but also the development of systems-based on computation.

Text

Supporting the Implementation of Digital Technologies in Disadvantaged Schools: Case study of impact, outcomes and sustainability (2020)

This PDF is an extensive report on the success of the Digital Technologies in Focus (DTiF) project, with a focus on supporting the Implementation of Digital Technologies in disadvantaged schools. The evaluation gathered qualitative data to create rich case study accounts of six schools' engagement in the project and its ...

Video

Supporting implementation of Digital Technologies and the ICT Capability: part 3

This video explains ways in which the Digital Technologies curriculum and the Information and Communication Technology (ICT) General Capability can be implemented in schools. This video is the last in a series of three.

Video

Computational thinking in the Australian Curriculum: Digital Technologies

This video provides an overview of computational thinking and how it can be taught in the context of other learning areas.

Text

Digital Technologies in the Australian Curriculum: overview and key links

This PDF gives an overview of the Australian Curriculum: Digital Technologies. It includes key points from the rationale and a step-by-step process for becoming familiar with the structure of the curriculum to assist planning. The document also provides links to key documents and sections of the Australian Curriculum as ...

Text

Planning an action research project to facilitate implementation of Digital Technologies

This PowerPoint presentation includes ideas for planning and developing action research projects to facilitate implementation of digital technologies.

Text

Volmert et al. review: STEM learning

This report examines the similarities and differences in the understandings about STEM education between experts and the general public in some American states. The authors contend that one of the most interesting findings is the role of Science: the general public equates STEM as Science, whereas the experts view all STEM ...

Text

Newsletter – October 2019

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, visual programming, the Australian Curriculum, and useful resources.

Text

Newsletter – April 2018

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, the Australian Curriculum and useful resources.

Video

DTiF in conversation with Kevin Bradley and Cassandra Arkinstall from Save the Bilby Fund – Using Digital Technologies to help save bilbies

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund explain how important digital technologies are in the campaign to save the bilby from extinction. The video explains how digital systems are used to collect and visualise data and help eradicate threats ...

Text

Supporting Digital Technologies curriculum in schools

This PDF lists seven ways in which schools can support the Digital Technologies curriculum

Text

Australian Curriculum: Digital Technologies Years 7–10 achievement standards and aligned content descriptions on a page

This PDF presents content descriptions and achievement standards for the Digital Technologies subject in the Australian Curriculum